Overview

Brought to you by YData

Dataset statistics

Number of variables	35
Number of observations	2568724
Missing cells	14872
Missing cells (%)	< 0.1%
Duplicate rows	14914
Duplicate rows (%)	0.6%
Total size in memory	2.1 GiB
Average record size in memory	861.6 B

Variable types

DateTime	1
Numeric	23
Text	6
Categorical	5

Alerts

Dataset has 14914 (0.6%) duplicate rows	Duplicates
`GINI` is highly overall correlated with `ingreso_laboral_promedio` and 1 other fields	High correlation
`IPUG` is highly overall correlated with `edad_promedio` and 2 other fields	High correlation
`ajustada_alineacion` is highly overall correlated with `alineación con portafolio estratégico` and 2 other fields	High correlation
`alineación con portafolio estratégico` is highly overall correlated with `ajustada_alineacion` and 2 other fields	High correlation
`cantidad` is highly overall correlated with `log_cantidad` and 2 other fields	High correlation
`cantidad_promedio` is highly overall correlated with `precio_promedio` and 3 other fields	High correlation
`categoria` is highly overall correlated with `categoria_macro`	High correlation
`categoria_macro` is highly overall correlated with `categoria`	High correlation
`edad_promedio` is highly overall correlated with `IPUG` and 2 other fields	High correlation
`id` is highly overall correlated with `num_pedidos` and 1 other fields	High correlation
`ingreso_laboral_promedio` is highly overall correlated with `GINI` and 4 other fields	High correlation
`log_cantidad` is highly overall correlated with `cantidad` and 2 other fields	High correlation
`log_precio` is highly overall correlated with `cantidad` and 2 other fields	High correlation
`log_valor` is highly overall correlated with `ajustada_alineacion` and 2 other fields	High correlation
`num_pedidos` is highly overall correlated with `id` and 2 other fields	High correlation
`pedido` is highly overall correlated with `id`	High correlation
`porcentaje_urbano` is highly overall correlated with `ingreso_laboral_promedio` and 1 other fields	High correlation
`precio` is highly overall correlated with `cantidad` and 2 other fields	High correlation
`precio_promedio` is highly overall correlated with `cantidad_promedio` and 1 other fields	High correlation
`ticket_promedio` is highly overall correlated with `cantidad_promedio` and 2 other fields	High correlation
`total_gasto` is highly overall correlated with `cantidad_promedio` and 3 other fields	High correlation
`total_productos` is highly overall correlated with `cantidad_promedio` and 4 other fields	High correlation
`valor` is highly overall correlated with `ajustada_alineacion` and 2 other fields	High correlation
`zona` is highly overall correlated with `GINI` and 4 other fields	High correlation
`cantidad` is highly skewed (γ1 = 407.6718452)	Skewed
`precio` is highly skewed (γ1 = 75.64533226)	Skewed
`valor` is highly skewed (γ1 = 88.62689348)	Skewed
`alineación con portafolio estratégico` is highly skewed (γ1 = -638.3338094)	Skewed
`ajustada_alineacion` is highly skewed (γ1 = -164.0441718)	Skewed
`total_productos` is highly skewed (γ1 = 23.56907809)	Skewed
`precio_promedio` is highly skewed (γ1 = 24.84345157)	Skewed
`cantidad_promedio` is highly skewed (γ1 = 73.01971405)	Skewed
`Total de edificaciones en obra` has 678206 (26.4%) zeros	Zeros

Reproduction

Analysis started	2025-04-06 05:45:04.610792
Analysis finished	2025-04-06 05:55:19.622739
Duration	10 minutes and 15.01 seconds
Software version	ydata-profiling vv4.16.1
Download configuration	config.json

fecha
Date

Distinct	756
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	19.6 MiB

Minimum	1971-01-02 00:00:00
Maximum	1973-01-31 00:00:00
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

pedido
Real number (ℝ)

High correlation

Distinct	933814
Distinct (%)	36.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	466252.12

Minimum	2
Maximum	933936
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	19.6 MiB

Quantile statistics

Minimum	2
5-th percentile	46643.15
Q1	230870
median	465819
Q3	701243
95-th percentile	887652
Maximum	933936
Range	933934
Interquartile range (IQR)	470373

Descriptive statistics

Standard deviation	270294.22
Coefficient of variation (CV)	0.57971688
Kurtosis	-1.2057948
Mean	466252.12
Median Absolute Deviation (MAD)	235227
Skewness	0.0035068703
Sum	1.197673 × 10¹²
Variance	7.3058966 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
589388	152	< 0.1%
431390	136	< 0.1%
47364	114	< 0.1%
679361	111	< 0.1%
918192	108	< 0.1%
17776	108	< 0.1%
488822	108	< 0.1%
918218	108	< 0.1%
607844	104	< 0.1%
573522	104	< 0.1%
Other values (933804)	2567571	> 99.9%

Value	Count	Frequency (%)
2	1	< 0.1%
3	4	< 0.1%
4	4	< 0.1%
5	4	< 0.1%
6	2	< 0.1%
7	8	< 0.1%
8	2	< 0.1%
9	4	< 0.1%
10	1	< 0.1%
11	4	< 0.1%

Value	Count	Frequency (%)
933936	2	< 0.1%
933935	1	< 0.1%
933934	1	< 0.1%
933933	3	< 0.1%
933932	1	< 0.1%
933931	1	< 0.1%
933930	1	< 0.1%
933929	2	< 0.1%
933928	2	< 0.1%
933927	4	< 0.1%

id
Real number (ℝ)

High correlation

Distinct	419222
Distinct (%)	16.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	165617.2

Minimum	1
Maximum	419226
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	19.6 MiB

Quantile statistics

Minimum	1
5-th percentile	9362
Q1	58899
median	138026
Q3	261522
95-th percentile	384302
Maximum	419226
Range	419225
Interquartile range (IQR)	202623

Descriptive statistics

Standard deviation	121181.67
Coefficient of variation (CV)	0.73169737
Kurtosis	-1.0227461
Mean	165617.2
Median Absolute Deviation (MAD)	94513
Skewness	0.45437008
Sum	4.2542488 × 10¹¹
Variance	1.4684998 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
3037	1735	0.1%
1236	1671	0.1%
2906	1555	0.1%
3121	1361	0.1%
3357	1318	0.1%
2412	1173	< 0.1%
30822	998	< 0.1%
4206	945	< 0.1%
28478	756	< 0.1%
512	644	< 0.1%
Other values (419212)	2556568	99.5%

Value	Count	Frequency (%)
1	85	< 0.1%
2	18	< 0.1%
3	4	< 0.1%
4	4	< 0.1%
5	20	< 0.1%
6	36	< 0.1%
7	20	< 0.1%
8	18	< 0.1%
9	92	< 0.1%
10	5	< 0.1%

Value	Count	Frequency (%)
419226	2	< 0.1%
419225	1	< 0.1%
419224	1	< 0.1%
419223	1	< 0.1%
419222	1	< 0.1%
419221	11	< 0.1%
419220	8	< 0.1%
419219	1	< 0.1%
419218	6	< 0.1%
419217	2	< 0.1%

edad
Real number (ℝ)

Distinct	50
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	41.752713

Minimum	18
Maximum	67
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	19.6 MiB

Quantile statistics

Minimum	18
5-th percentile	29
Q1	31
median	43
Q3	48
95-th percentile	58
Maximum	67
Range	49
Interquartile range (IQR)	17

Descriptive statistics

Standard deviation	9.5305458
Coefficient of variation (CV)	0.22826172
Kurtosis	-0.91711203
Mean	41.752713
Median Absolute Deviation (MAD)	8
Skewness	0.17876145
Sum	1.072512 × 10⁸
Variance	90.831304
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
31	402001	15.6%
45	154275	6.0%
43	151451	5.9%
47	110215	4.3%
41	108391	4.2%
40	95676	3.7%
50	91581	3.6%
30	91125	3.5%
46	88733	3.5%
42	86804	3.4%
Other values (40)	1188472	46.3%

Value	Count	Frequency (%)
18	11	< 0.1%
19	240	< 0.1%
20	234	< 0.1%
21	575	< 0.1%
22	4635	0.2%
23	9742	0.4%
24	6819	0.3%
25	10180	0.4%
26	17266	0.7%
27	25943	1.0%

Value	Count	Frequency (%)
67	466	< 0.1%
66	22	< 0.1%
65	90	< 0.1%
64	21378	0.8%
63	2448	0.1%
62	7280	0.3%
61	5786	0.2%
60	33558	1.3%
59	31561	1.2%
58	57713	2.2%

municipio
Text

Distinct	807
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	140.9 MiB

Length

Max length	27
Median length	26
Mean length	8.5339153
Min length	3

Characters and Unicode

Total characters	21921273
Distinct characters	35
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	31 ?
Unique (%)	< 0.1%

Sample

1st row	EL CARMEN DE CHUCURI
2nd row	VILLANUEVA
3rd row	VILLANUEVA
4th row	VILLANUEVA
5th row	VILLANUEVA

Value	Count	Frequency (%)
curiti	575851	19.3%
villanueva	569096	19.1%
natagaima	344938	11.6%
guatica	130373	4.4%
girardota	76933	2.6%
de	73795	2.5%
santa	55005	1.8%
matias	41568	1.4%
don	41568	1.4%
la	41561	1.4%
Other values (808)	1032091	34.6%

Most occurring characters

Value	Count	Frequency (%)
A	4411816	20.1%
I	2769839	12.6%
U	1603758	7.3%
T	1514641	6.9%
L	1511166	6.9%
N	1433658	6.5%
R	1293458	5.9%
V	1237070	5.6%
E	1222356	5.6%
C	1085694	5.0%
Other values (25)	3837817	17.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	21921273	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
A	4411816	20.1%
I	2769839	12.6%
U	1603758	7.3%
T	1514641	6.9%
L	1511166	6.9%
N	1433658	6.5%
R	1293458	5.9%
V	1237070	5.6%
E	1222356	5.6%
C	1085694	5.0%
Other values (25)	3837817	17.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	21921273	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
A	4411816	20.1%
I	2769839	12.6%
U	1603758	7.3%
T	1514641	6.9%
L	1511166	6.9%
N	1433658	6.5%
R	1293458	5.9%
V	1237070	5.6%
E	1222356	5.6%
C	1085694	5.0%
Other values (25)	3837817	17.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	21921273	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
A	4411816	20.1%
I	2769839	12.6%
U	1603758	7.3%
T	1514641	6.9%
L	1511166	6.9%
N	1433658	6.5%
R	1293458	5.9%
V	1237070	5.6%
E	1222356	5.6%
C	1085694	5.0%
Other values (25)	3837817	17.5%

zona
Categorical

High correlation

Distinct	34
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	143.0 MiB

SANTANDER	739403
LA GUAJIRA	572599
TOLIMA	407942
ANTIOQUIA	226327
RISARALDA	132899
Other values (29)	489554

Length

Max length	15
Median length	12
Mean length	8.6370447
Min length	4

Characters and Unicode

Total characters	22186184
Distinct characters	30
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	SANTANDER
2nd row	LA GUAJIRA
3rd row	LA GUAJIRA
4th row	LA GUAJIRA
5th row	LA GUAJIRA

Common Values

Value	Count	Frequency (%)
SANTANDER	739403	28.8%
LA GUAJIRA	572599	22.3%
TOLIMA	407942	15.9%
ANTIOQUIA	226327	8.8%
RISARALDA	132899	5.2%
CUNDINAMARCA	107104	4.2%
NORTE SANTANDER	59121	2.3%
BOYACA	50586	2.0%
CAUCA	39420	1.5%
HUILA	36280	1.4%
Other values (24)	197043	7.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
santander	798524	24.9%
la	572599	17.9%
guajira	572599	17.9%
tolima	407942	12.7%
antioquia	226327	7.1%
risaralda	132899	4.2%
cundinamarca	107104	3.3%
norte	59121	1.8%
boyaca	50586	1.6%
cauca	39420	1.2%
Other values (26)	233557	7.3%

Most occurring characters

Value	Count	Frequency (%)
A	5370583	24.2%
N	2186344	9.9%
R	1880810	8.5%
I	1772480	8.0%
T	1589719	7.2%
L	1268729	5.7%
D	1062422	4.8%
U	994194	4.5%
S	973844	4.4%
E	959161	4.3%
Other values (20)	4127898	18.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	22186184	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
A	5370583	24.2%
N	2186344	9.9%
R	1880810	8.5%
I	1772480	8.0%
T	1589719	7.2%
L	1268729	5.7%
D	1062422	4.8%
U	994194	4.5%
S	973844	4.4%
E	959161	4.3%
Other values (20)	4127898	18.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	22186184	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
A	5370583	24.2%
N	2186344	9.9%
R	1880810	8.5%
I	1772480	8.0%
T	1589719	7.2%
L	1268729	5.7%
D	1062422	4.8%
U	994194	4.5%
S	973844	4.4%
E	959161	4.3%
Other values (20)	4127898	18.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	22186184	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
A	5370583	24.2%
N	2186344	9.9%
R	1880810	8.5%
I	1772480	8.0%
T	1589719	7.2%
L	1268729	5.7%
D	1062422	4.8%
U	994194	4.5%
S	973844	4.4%
E	959161	4.3%
Other values (20)	4127898	18.6%

asesor
Text

Distinct	608
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	143.5 MiB

Length

Max length	10
Median length	10
Mean length	9.5900871
Min length	8

Characters and Unicode

Total characters	24634287
Distinct characters	16
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	18 ?
Unique (%)	< 0.1%

Sample

1st row	asesor_2
2nd row	asesor_3
3rd row	asesor_3
4th row	asesor_3
5th row	asesor_3

Value	Count	Frequency (%)
asesor_137	42270	1.6%
asesor_251	40478	1.6%
asesor_7	39721	1.5%
asesor_197	32477	1.3%
asesor_122	31884	1.2%
asesor_9	31405	1.2%
asesor_103	30051	1.2%
asesor_255	29499	1.1%
asesor_397	28404	1.1%
asesor_2	27953	1.1%
Other values (598)	2234582	87.0%

Most occurring characters

Value	Count	Frequency (%)
s	5137448	20.9%
a	2568724	10.4%
e	2568724	10.4%
o	2568724	10.4%
r	2568724	10.4%
_	2568724	10.4%
1	1379679	5.6%
2	1054242	4.3%
3	789343	3.2%
7	612227	2.5%
Other values (6)	2817728	11.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	24634287	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
s	5137448	20.9%
a	2568724	10.4%
e	2568724	10.4%
o	2568724	10.4%
r	2568724	10.4%
_	2568724	10.4%
1	1379679	5.6%
2	1054242	4.3%
3	789343	3.2%
7	612227	2.5%
Other values (6)	2817728	11.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	24634287	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
s	5137448	20.9%
a	2568724	10.4%
e	2568724	10.4%
o	2568724	10.4%
r	2568724	10.4%
_	2568724	10.4%
1	1379679	5.6%
2	1054242	4.3%
3	789343	3.2%
7	612227	2.5%
Other values (6)	2817728	11.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	24634287	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
s	5137448	20.9%
a	2568724	10.4%
e	2568724	10.4%
o	2568724	10.4%
r	2568724	10.4%
_	2568724	10.4%
1	1379679	5.6%
2	1054242	4.3%
3	789343	3.2%
7	612227	2.5%
Other values (6)	2817728	11.4%

punto de venta
Text

Distinct	66
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	153.3 MiB

Length

Max length	14
Median length	14
Mean length	13.588146
Min length	13

Characters and Unicode

Total characters	34904198
Distinct characters	19
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	punto_venta_2
2nd row	punto_venta_2
3rd row	punto_venta_2
4th row	punto_venta_2
5th row	punto_venta_2

Value	Count	Frequency (%)
punto_venta_2	343666	13.4%
punto_venta_33	194569	7.6%
punto_venta_7	132891	5.2%
punto_venta_4	124219	4.8%
punto_venta_6	116909	4.6%
punto_venta_21	112599	4.4%
punto_venta_10	107327	4.2%
punto_venta_9	101799	4.0%
punto_venta_3	84689	3.3%
punto_venta_1	74783	2.9%
Other values (56)	1175273	45.8%

Most occurring characters

Value	Count	Frequency (%)
n	5137448	14.7%
t	5137448	14.7%
_	5137448	14.7%
p	2568724	7.4%
u	2568724	7.4%
o	2568724	7.4%
v	2568724	7.4%
e	2568724	7.4%
a	2568724	7.4%
2	999527	2.9%
Other values (9)	3079983	8.8%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	34904198	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
n	5137448	14.7%
t	5137448	14.7%
_	5137448	14.7%
p	2568724	7.4%
u	2568724	7.4%
o	2568724	7.4%
v	2568724	7.4%
e	2568724	7.4%
a	2568724	7.4%
2	999527	2.9%
Other values (9)	3079983	8.8%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	34904198	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
n	5137448	14.7%
t	5137448	14.7%
_	5137448	14.7%
p	2568724	7.4%
u	2568724	7.4%
o	2568724	7.4%
v	2568724	7.4%
e	2568724	7.4%
a	2568724	7.4%
2	999527	2.9%
Other values (9)	3079983	8.8%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	34904198	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
n	5137448	14.7%
t	5137448	14.7%
_	5137448	14.7%
p	2568724	7.4%
u	2568724	7.4%
o	2568724	7.4%
v	2568724	7.4%
e	2568724	7.4%
a	2568724	7.4%
2	999527	2.9%
Other values (9)	3079983	8.8%

cluster
Categorical

Distinct	9
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	159.2 MiB

cluster_tienda_3	1158447
cluster_tienda_2	1071931
cluster_tienda_1	209912
cluster_tienda_4	98969
cluster_tienda_5	26635
Other values (4)	2830

Length

Max length	16
Median length	16
Mean length	16
Min length	16

Characters and Unicode

Total characters	41099584
Distinct characters	21
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	cluster_tienda_2
2nd row	cluster_tienda_2
3rd row	cluster_tienda_2
4th row	cluster_tienda_2
5th row	cluster_tienda_2

Common Values

Value	Count	Frequency (%)
cluster_tienda_3	1158447	45.1%
cluster_tienda_2	1071931	41.7%
cluster_tienda_1	209912	8.2%
cluster_tienda_4	98969	3.9%
cluster_tienda_5	26635	1.0%
cluster_tienda_6	1246	< 0.1%
cluster_tienda_8	830	< 0.1%
cluster_tienda_7	753	< 0.1%
cluster_tienda_9	1	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
cluster_tienda_3	1158447	45.1%
cluster_tienda_2	1071931	41.7%
cluster_tienda_1	209912	8.2%
cluster_tienda_4	98969	3.9%
cluster_tienda_5	26635	1.0%
cluster_tienda_6	1246	< 0.1%
cluster_tienda_8	830	< 0.1%
cluster_tienda_7	753	< 0.1%
cluster_tienda_9	1	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
t	5137448	12.5%
e	5137448	12.5%
_	5137448	12.5%
c	2568724	6.2%
i	2568724	6.2%
a	2568724	6.2%
l	2568724	6.2%
n	2568724	6.2%
d	2568724	6.2%
r	2568724	6.2%
Other values (11)	7706172	18.8%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	41099584	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
t	5137448	12.5%
e	5137448	12.5%
_	5137448	12.5%
c	2568724	6.2%
i	2568724	6.2%
a	2568724	6.2%
l	2568724	6.2%
n	2568724	6.2%
d	2568724	6.2%
r	2568724	6.2%
Other values (11)	7706172	18.8%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	41099584	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
t	5137448	12.5%
e	5137448	12.5%
_	5137448	12.5%
c	2568724	6.2%
i	2568724	6.2%
a	2568724	6.2%
l	2568724	6.2%
n	2568724	6.2%
d	2568724	6.2%
r	2568724	6.2%
Other values (11)	7706172	18.8%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	41099584	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
t	5137448	12.5%
e	5137448	12.5%
_	5137448	12.5%
c	2568724	6.2%
i	2568724	6.2%
a	2568724	6.2%
l	2568724	6.2%
n	2568724	6.2%
d	2568724	6.2%
r	2568724	6.2%
Other values (11)	7706172	18.8%

categoria_macro
Categorical

High correlation

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	161.7 MiB

categoria_macro_2	1602004
categoria_macro_4	620206
categoria_macro_1	221863
categoria_macro_3	112996
categoria_macro_5	11655

Length

Max length	17
Median length	17
Mean length	17
Min length	17

Characters and Unicode

Total characters	43668308
Distinct characters	15
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	categoria_macro_1
2nd row	categoria_macro_2
3rd row	categoria_macro_2
4th row	categoria_macro_2
5th row	categoria_macro_2

Common Values

Value	Count	Frequency (%)
categoria_macro_2	1602004	62.4%
categoria_macro_4	620206	24.1%
categoria_macro_1	221863	8.6%
categoria_macro_3	112996	4.4%
categoria_macro_5	11655	0.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
categoria_macro_2	1602004	62.4%
categoria_macro_4	620206	24.1%
categoria_macro_1	221863	8.6%
categoria_macro_3	112996	4.4%
categoria_macro_5	11655	0.5%

Most occurring characters

Value	Count	Frequency (%)
a	7706172	17.6%
c	5137448	11.8%
o	5137448	11.8%
r	5137448	11.8%
_	5137448	11.8%
t	2568724	5.9%
e	2568724	5.9%
g	2568724	5.9%
i	2568724	5.9%
m	2568724	5.9%
Other values (5)	2568724	5.9%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	43668308	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	7706172	17.6%
c	5137448	11.8%
o	5137448	11.8%
r	5137448	11.8%
_	5137448	11.8%
t	2568724	5.9%
e	2568724	5.9%
g	2568724	5.9%
i	2568724	5.9%
m	2568724	5.9%
Other values (5)	2568724	5.9%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	43668308	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	7706172	17.6%
c	5137448	11.8%
o	5137448	11.8%
r	5137448	11.8%
_	5137448	11.8%
t	2568724	5.9%
e	2568724	5.9%
g	2568724	5.9%
i	2568724	5.9%
m	2568724	5.9%
Other values (5)	2568724	5.9%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	43668308	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	7706172	17.6%
c	5137448	11.8%
o	5137448	11.8%
r	5137448	11.8%
_	5137448	11.8%
t	2568724	5.9%
e	2568724	5.9%
g	2568724	5.9%
i	2568724	5.9%
m	2568724	5.9%
Other values (5)	2568724	5.9%

categoria
Categorical

High correlation

Distinct	27
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	147.5 MiB

categoria_3	566967
categoria_7	535182
categoria_5	359200
categoria_11	195663
categoria_1	176468
Other values (22)	735244

Length

Max length	12
Median length	11
Mean length	11.213218
Min length	11

Characters and Unicode

Total characters	28803661
Distinct characters	19
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	categoria_2
2nd row	categoria_3
3rd row	categoria_3
4th row	categoria_3
5th row	categoria_3

Common Values

Value	Count	Frequency (%)
categoria_3	566967	22.1%
categoria_7	535182	20.8%
categoria_5	359200	14.0%
categoria_11	195663	7.6%
categoria_1	176468	6.9%
categoria_12	162338	6.3%
categoria_8	138936	5.4%
categoria_9	100276	3.9%
categoria_10	65163	2.5%
categoria_6	59967	2.3%
Other values (17)	208564	8.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
categoria_3	566967	22.1%
categoria_7	535182	20.8%
categoria_5	359200	14.0%
categoria_11	195663	7.6%
categoria_1	176468	6.9%
categoria_12	162338	6.3%
categoria_8	138936	5.4%
categoria_9	100276	3.9%
categoria_10	65163	2.5%
categoria_6	59967	2.3%
Other values (17)	208564	8.1%

Most occurring characters

Value	Count	Frequency (%)
a	5137448	17.8%
c	2568724	8.9%
t	2568724	8.9%
e	2568724	8.9%
g	2568724	8.9%
o	2568724	8.9%
r	2568724	8.9%
i	2568724	8.9%
_	2568724	8.9%
1	895544	3.1%
Other values (9)	2220877	7.7%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	28803661	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	5137448	17.8%
c	2568724	8.9%
t	2568724	8.9%
e	2568724	8.9%
g	2568724	8.9%
o	2568724	8.9%
r	2568724	8.9%
i	2568724	8.9%
_	2568724	8.9%
1	895544	3.1%
Other values (9)	2220877	7.7%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	28803661	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	5137448	17.8%
c	2568724	8.9%
t	2568724	8.9%
e	2568724	8.9%
g	2568724	8.9%
o	2568724	8.9%
r	2568724	8.9%
i	2568724	8.9%
_	2568724	8.9%
1	895544	3.1%
Other values (9)	2220877	7.7%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	28803661	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	5137448	17.8%
c	2568724	8.9%
t	2568724	8.9%
e	2568724	8.9%
g	2568724	8.9%
o	2568724	8.9%
r	2568724	8.9%
i	2568724	8.9%
_	2568724	8.9%
1	895544	3.1%
Other values (9)	2220877	7.7%

subcategoria
Text

Distinct	102
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	155.4 MiB

Length

Max length	16
Median length	14
Mean length	14.426673
Min length	14

Characters and Unicode

Total characters	37058142
Distinct characters	22
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	3 ?
Unique (%)	< 0.1%

Sample

1st row	subcategoria_2
2nd row	subcategoria_3
3rd row	subcategoria_3
4th row	subcategoria_3
5th row	subcategoria_3

Value	Count	Frequency (%)
subcategoria_5	822252	32.0%
subcategoria_3	296439	11.5%
subcategoria_9	194553	7.6%
subcategoria_12	94339	3.7%
subcategoria_14	87146	3.4%
subcategoria_22	75970	3.0%
subcategoria_7	72048	2.8%
subcategoria_13	62574	2.4%
subcategoria_39	61477	2.4%
subcategoria_24	58349	2.3%
Other values (92)	743577	28.9%

Most occurring characters

Value	Count	Frequency (%)
a	5137448	13.9%
s	2568724	6.9%
g	2568724	6.9%
u	2568724	6.9%
i	2568724	6.9%
r	2568724	6.9%
o	2568724	6.9%
_	2568724	6.9%
e	2568724	6.9%
t	2568724	6.9%
Other values (12)	8802178	23.8%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	37058142	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	5137448	13.9%
s	2568724	6.9%
g	2568724	6.9%
u	2568724	6.9%
i	2568724	6.9%
r	2568724	6.9%
o	2568724	6.9%
_	2568724	6.9%
e	2568724	6.9%
t	2568724	6.9%
Other values (12)	8802178	23.8%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	37058142	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	5137448	13.9%
s	2568724	6.9%
g	2568724	6.9%
u	2568724	6.9%
i	2568724	6.9%
r	2568724	6.9%
o	2568724	6.9%
_	2568724	6.9%
e	2568724	6.9%
t	2568724	6.9%
Other values (12)	8802178	23.8%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	37058142	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	5137448	13.9%
s	2568724	6.9%
g	2568724	6.9%
u	2568724	6.9%
i	2568724	6.9%
r	2568724	6.9%
o	2568724	6.9%
_	2568724	6.9%
e	2568724	6.9%
t	2568724	6.9%
Other values (12)	8802178	23.8%

producto
Text

Distinct	7263
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	149.3 MiB

Length

Max length	13
Median length	12
Mean length	11.963088
Min length	10

Characters and Unicode

Total characters	30729870
Distinct characters	18
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	958 ?
Unique (%)	< 0.1%

Sample

1st row	producto_2
2nd row	producto_3
3rd row	producto_3
4th row	producto_3
5th row	producto_3

Value	Count	Frequency (%)
producto_19	69248	2.7%
producto_49	61396	2.4%
producto_40	32927	1.3%
producto_28	32313	1.3%
producto_176	31598	1.2%
producto_3	30504	1.2%
producto_110	30023	1.2%
producto_72	27744	1.1%
producto_119	26915	1.0%
producto_112	25300	1.0%
Other values (7253)	2200756	85.7%

Most occurring characters

Value	Count	Frequency (%)
o	5137448	16.7%
p	2568724	8.4%
d	2568724	8.4%
u	2568724	8.4%
c	2568724	8.4%
t	2568724	8.4%
_	2568724	8.4%
r	2568724	8.4%
1	1374583	4.5%
2	911738	3.0%
Other values (8)	5325033	17.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	30729870	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
o	5137448	16.7%
p	2568724	8.4%
d	2568724	8.4%
u	2568724	8.4%
c	2568724	8.4%
t	2568724	8.4%
_	2568724	8.4%
r	2568724	8.4%
1	1374583	4.5%
2	911738	3.0%
Other values (8)	5325033	17.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	30729870	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
o	5137448	16.7%
p	2568724	8.4%
d	2568724	8.4%
u	2568724	8.4%
c	2568724	8.4%
t	2568724	8.4%
_	2568724	8.4%
r	2568724	8.4%
1	1374583	4.5%
2	911738	3.0%
Other values (8)	5325033	17.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	30729870	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
o	5137448	16.7%
p	2568724	8.4%
d	2568724	8.4%
u	2568724	8.4%
c	2568724	8.4%
t	2568724	8.4%
_	2568724	8.4%
r	2568724	8.4%
1	1374583	4.5%
2	911738	3.0%
Other values (8)	5325033	17.3%

color
Text

Distinct	68
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	141.8 MiB

Length

Max length	13
Median length	12
Mean length	8.8936266
Min length	3

Characters and Unicode

Total characters	22845272
Distinct characters	36
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	3 ?
Unique (%)	< 0.1%

Sample

1st row	GRIS
2nd row	BEIGE
3rd row	BEIGE
4th row	BEIGE
5th row	BEIGE

Value	Count	Frequency (%)
no	1196257	31.8%
encontrado	1196257	31.8%
gris	515685	13.7%
blanco	303687	8.1%
beige	220542	5.9%
multicolor	106369	2.8%
marfil	54243	1.4%
negro	48494	1.3%
azul	35037	0.9%
mate	18145	0.5%
Other values (59)	70265	1.9%

Most occurring characters

Value	Count	Frequency (%)
o	3588771	15.7%
n	2392514	10.5%
N	1575543	6.9%
	1196257	5.2%
e	1196257	5.2%
c	1196257	5.2%
t	1196257	5.2%
r	1196257	5.2%
a	1196257	5.2%
d	1196257	5.2%
Other values (26)	6914645	30.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	22845272	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
o	3588771	15.7%
n	2392514	10.5%
N	1575543	6.9%
	1196257	5.2%
e	1196257	5.2%
c	1196257	5.2%
t	1196257	5.2%
r	1196257	5.2%
a	1196257	5.2%
d	1196257	5.2%
Other values (26)	6914645	30.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	22845272	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
o	3588771	15.7%
n	2392514	10.5%
N	1575543	6.9%
	1196257	5.2%
e	1196257	5.2%
c	1196257	5.2%
t	1196257	5.2%
r	1196257	5.2%
a	1196257	5.2%
d	1196257	5.2%
Other values (26)	6914645	30.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	22845272	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
o	3588771	15.7%
n	2392514	10.5%
N	1575543	6.9%
	1196257	5.2%
e	1196257	5.2%
c	1196257	5.2%
t	1196257	5.2%
r	1196257	5.2%
a	1196257	5.2%
d	1196257	5.2%
Other values (26)	6914645	30.3%

cantidad
Real number (ℝ)

High correlation Skewed

Distinct	6229
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	36.601075

Minimum	0.15
Maximum	489689
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	19.6 MiB

Quantile statistics

Minimum	0.15
5-th percentile	1
Q1	1
median	3
Q3	12.8
95-th percentile	140.14
Maximum	489689
Range	489688.85
Interquartile range (IQR)	11.8

Descriptive statistics

Standard deviation	680.68267
Coefficient of variation (CV)	18.597341
Kurtosis	238348.65
Mean	36.601075
Median Absolute Deviation (MAD)	2
Skewness	407.67185
Sum	94018061
Variance	463328.9
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	725909	28.3%
2	327616	12.8%
5	91126	3.5%
25	59469	2.3%
4	57452	2.2%
3	49614	1.9%
10	42112	1.6%
50	39743	1.5%
6	26796	1.0%
3.2	26434	1.0%
Other values (6219)	1122453	43.7%

Value	Count	Frequency (%)
0.15	1	< 0.1%
0.33	1	< 0.1%
0.4	33	< 0.1%
0.42	1	< 0.1%
0.48	91	< 0.1%
0.5	13	< 0.1%
0.52	16	< 0.1%
0.54	38	< 0.1%
0.57	1	< 0.1%
0.61	1	< 0.1%

Value	Count	Frequency (%)
489689	1	< 0.1%
477673	1	< 0.1%
264542	1	< 0.1%
262179	1	< 0.1%
251039	1	< 0.1%
246562	1	< 0.1%
189346	1	< 0.1%
167730	1	< 0.1%
162539	1	< 0.1%
130591	1	< 0.1%

precio
Real number (ℝ)

High correlation Skewed

Distinct	9635
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	9.0983616

Minimum	0
Maximum	12043.48
Zeros	67
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	19.6 MiB

Quantile statistics

Minimum	0
5-th percentile	0.12
Q1	0.65
median	3.01
Q3	6.16
95-th percentile	43
Maximum	12043.48
Range	12043.48
Interquartile range (IQR)	5.51

Descriptive statistics

Standard deviation	28.918855
Coefficient of variation (CV)	3.1784684
Kurtosis	18258.202
Mean	9.0983616
Median Absolute Deviation (MAD)	2.41
Skewness	75.645332
Sum	23371180
Variance	836.30017
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.56	54220	2.1%
0.6	47463	1.8%
0.5	45569	1.8%
0.47	40941	1.6%
0.07	36285	1.4%
0.65	35864	1.4%
0.15	31009	1.2%
0.11	27962	1.1%
0.13	26860	1.0%
0.58	24410	1.0%
Other values (9625)	2198141	85.6%

Value	Count	Frequency (%)
0	67	< 0.1%
0.01	2	< 0.1%
0.04	373	< 0.1%
0.05	60	< 0.1%
0.06	2832	0.1%
0.07	36285	1.4%
0.08	23595	0.9%
0.09	23979	0.9%
0.1	3888	0.2%
0.11	27962	1.1%

Value	Count	Frequency (%)
12043.48	1	< 0.1%
6451.52	1	< 0.1%
5833.75	1	< 0.1%
5592.58	1	< 0.1%
5591.54	4	< 0.1%
4955.1	1	< 0.1%
4816.04	1	< 0.1%
4099.78	1	< 0.1%
4044.55	1	< 0.1%
3846.93	2	< 0.1%

valor
Real number (ℝ)

High correlation Skewed

Distinct	46578
Distinct (%)	1.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	38.472455

Minimum	0.07
Maximum	56876.09
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	19.6 MiB

Quantile statistics

Minimum	0.07
5-th percentile	1.14
Q1	4.69
median	12.9
Q3	36.2
95-th percentile	142.1785
Maximum	56876.09
Range	56876.02
Interquartile range (IQR)	31.51

Descriptive statistics

Standard deviation	153.75788
Coefficient of variation (CV)	3.9965705
Kurtosis	20340.008
Mean	38.472455
Median Absolute Deviation (MAD)	10.48
Skewness	88.626893
Sum	98825118
Variance	23641.485
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1.13	42912	1.7%
1.2	40207	1.6%
2.34	25645	1.0%
1.3	22891	0.9%
2.49	20050	0.8%
0.35	16851	0.7%
1.17	16328	0.6%
2.67	11964	0.5%
2.5	11937	0.5%
4.69	9564	0.4%
Other values (46568)	2350375	91.5%

Value	Count	Frequency (%)
0.07	32	< 0.1%
0.08	2	< 0.1%
0.09	22	< 0.1%
0.1	39	< 0.1%
0.11	19	< 0.1%
0.12	40	< 0.1%
0.13	235	< 0.1%
0.14	32	< 0.1%
0.15	86	< 0.1%
0.16	10	< 0.1%

Value	Count	Frequency (%)
56876.09	1	< 0.1%
55491.7	1	< 0.1%
32647.37	1	< 0.1%
32398.94	1	< 0.1%
30571.52	1	< 0.1%
30508.79	1	< 0.1%
30434.9	1	< 0.1%
29158.44	1	< 0.1%
28599.27	1	< 0.1%
24053.41	1	< 0.1%

alineación con portafolio estratégico
Real number (ℝ)

High correlation Skewed

Distinct	24003
Distinct (%)	0.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.8254732

Minimum	-24187.463
Maximum	4162.2266
Zeros	1672
Zeros (%)	0.1%
Negative	1520
Negative (%)	0.1%
Memory size	19.6 MiB

Quantile statistics

Minimum	-24187.463
5-th percentile	0.117504
Q1	0.46656
median	1.3824
Q3	3.652992
95-th percentile	13.78944
Maximum	4162.2266
Range	28349.69
Interquartile range (IQR)	3.186432

Descriptive statistics

Standard deviation	20.320648
Coefficient of variation (CV)	5.3119306
Kurtosis	784122.68
Mean	3.8254732
Median Absolute Deviation (MAD)	1.1232
Skewness	-638.33381
Sum	9826584.8
Variance	412.92873
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.124416	45432	1.8%
0.117504	42682	1.7%
0.2592	31017	1.2%
0.134784	26327	1.0%
0.048384	23665	0.9%
0.245376	23210	0.9%
0.12096	15691	0.6%
0.487296	13989	0.5%
0.27648	13468	0.5%
0.5184	10708	0.4%
Other values (23993)	2322535	90.4%

Value	Count	Frequency (%)
-24187.463	1	< 0.1%
-1712.1749	1	< 0.1%
-796.1898	1	< 0.1%
-701.06	1	< 0.1%
-684.16016	1	< 0.1%
-497.7262	1	< 0.1%
-455.72888	1	< 0.1%
-215.04614	1	< 0.1%
-193.44269	1	< 0.1%
-78.08832	4	< 0.1%

Value	Count	Frequency (%)
4162.2266	1	< 0.1%
3887.008	1	< 0.1%
2969.6543	1	< 0.1%
2900.6692	1	< 0.1%
2229.6453	1	< 0.1%
2158.8525	1	< 0.1%
2016.144	1	< 0.1%
1932.7957	1	< 0.1%
1932.4363	4	< 0.1%
1788.9984	1	< 0.1%

log_cantidad
Real number (ℝ)

High correlation

Distinct	6229
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.9180917

Minimum	0.13976195
Maximum	13.101528
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	19.6 MiB

Quantile statistics

Minimum	0.13976195
5-th percentile	0.6931472
Q1	0.6931472
median	1.3862944
Q3	2.6246686
95-th percentile	4.9497523
Maximum	13.101528
Range	12.961766
Interquartile range (IQR)	1.9315214

Descriptive statistics

Standard deviation	1.4139768
Coefficient of variation (CV)	0.73717895
Kurtosis	1.4442283
Mean	1.9180917
Median Absolute Deviation (MAD)	0.6931472
Skewness	1.3756699
Sum	4927048.2
Variance	1.9993304
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.6931472	725909	28.3%
1.0986123	327616	12.8%
1.7917595	91126	3.5%
3.2580965	59469	2.3%
1.609438	57452	2.2%
1.3862944	49614	1.9%
2.3978953	42112	1.6%
3.9318256	39743	1.5%
1.9459101	26796	1.0%
1.4350845	26434	1.0%
Other values (6219)	1122453	43.7%

Value	Count	Frequency (%)
0.13976195	1	< 0.1%
0.28517896	1	< 0.1%
0.33647224	33	< 0.1%
0.35065687	1	< 0.1%
0.39204207	91	< 0.1%
0.4054651	13	< 0.1%
0.41871032	16	< 0.1%
0.43178242	38	< 0.1%
0.4510756	1	< 0.1%
0.4762342	1	< 0.1%

Value	Count	Frequency (%)
13.101528	1	< 0.1%
13.076684	1	< 0.1%
12.485759	1	< 0.1%
12.476787	1	< 0.1%
12.433368	1	< 0.1%
12.415373	1	< 0.1%
12.151337	1	< 0.1%
12.030117	1	< 0.1%
11.998679	1	< 0.1%
11.779833	1	< 0.1%

log_precio
Real number (ℝ)

High correlation

Distinct	9635
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.5204145

Minimum	0
Maximum	9.396361
Zeros	67
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	19.6 MiB

Quantile statistics

Minimum	0
5-th percentile	0.11332868
Q1	0.5007753
median	1.3887913
Q3	1.9685099
95-th percentile	3.7841897
Maximum	9.396361
Range	9.396361
Interquartile range (IQR)	1.4677346

Descriptive statistics

Standard deviation	1.0945442
Coefficient of variation (CV)	0.71989856
Kurtosis	0.48589673
Mean	1.5204145
Median Absolute Deviation (MAD)	0.6981223
Skewness	0.90810704
Sum	3905525.3
Variance	1.198027
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.44468582	54220	2.1%
0.47000363	47463	1.8%
0.4054651	45569	1.8%
0.3852624	40941	1.6%
0.06765865	36285	1.4%
0.5007753	35864	1.4%
0.13976195	31009	1.2%
0.104360014	27962	1.1%
0.122217625	26860	1.0%
0.45742482	24410	1.0%
Other values (9625)	2198141	85.6%

Value	Count	Frequency (%)
0	67	< 0.1%
0.0099503305	2	< 0.1%
0.039220713	373	< 0.1%
0.048790164	60	< 0.1%
0.058268905	2832	0.1%
0.06765865	36285	1.4%
0.07696103	23595	0.9%
0.0861777	23979	0.9%
0.09531018	3888	0.2%
0.104360014	27962	1.1%

Value	Count	Frequency (%)
9.396361	1	< 0.1%
8.772226	1	< 0.1%
8.671587	1	< 0.1%
8.6293745	1	< 0.1%
8.629189	4	< 0.1%
8.508374	1	< 0.1%
8.479915	1	< 0.1%
8.318933	1	< 0.1%
8.305373	1	< 0.1%
8.255291	2	< 0.1%

log_valor
Real number (ℝ)

High correlation

Distinct	46578
Distinct (%)	1.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.7006973

Minimum	0.06765865
Maximum	10.948647
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	19.6 MiB

Quantile statistics

Minimum	0.06765865
5-th percentile	0.76080585
Q1	1.7387103
median	2.6318889
Q3	3.6163087
95-th percentile	4.9640922
Maximum	10.948647
Range	10.880989
Interquartile range (IQR)	1.8775984

Descriptive statistics

Standard deviation	1.3098293
Coefficient of variation (CV)	0.48499673
Kurtosis	-0.25988857
Mean	2.7006973
Median Absolute Deviation (MAD)	0.9362734
Skewness	0.35403333
Sum	6937345.9
Variance	1.7156529
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.756122	42912	1.7%
0.7884574	40207	1.6%
1.2059708	25645	1.0%
0.8329091	22891	0.9%
1.2499018	20050	0.8%
0.3001046	16851	0.7%
0.77472717	16328	0.6%
1.3001916	11964	0.5%
1.2527629	11937	0.5%
1.7387103	9564	0.4%
Other values (46568)	2350375	91.5%

Value	Count	Frequency (%)
0.06765865	32	< 0.1%
0.07696103	2	< 0.1%
0.0861777	22	< 0.1%
0.09531018	39	< 0.1%
0.104360014	19	< 0.1%
0.11332868	40	< 0.1%
0.122217625	235	< 0.1%
0.13102826	32	< 0.1%
0.13976195	86	< 0.1%
0.14842	10	< 0.1%

Value	Count	Frequency (%)
10.9486475	1	< 0.1%
10.924006	1	< 0.1%
10.39355	1	< 0.1%
10.385912	1	< 0.1%
10.327857	1	< 0.1%
10.325803	1	< 0.1%
10.323379	1	< 0.1%
10.280534	1	< 0.1%
10.261171	1	< 0.1%
10.088074	1	< 0.1%

ajustada_alineacion
Real number (ℝ)

High correlation Skewed

Distinct	24003
Distinct (%)	0.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-0.0067968525

Minimum	-771.33545
Maximum	276.4262
Zeros	0
Zeros (%)	0.0%
Negative	1997360
Negative (%)	77.8%
Memory size	19.6 MiB

Quantile statistics

Minimum	-771.33545
5-th percentile	-0.2011434
Q1	-0.184258
median	-0.13917093
Q3	-0.024373926
95-th percentile	0.5112163
Maximum	276.4262
Range	1047.7616
Interquartile range (IQR)	0.15988407

Descriptive statistics

Standard deviation	0.94209111
Coefficient of variation (CV)	-138.60697
Kurtosis	183559.67
Mean	-0.0067968525
Median Absolute Deviation (MAD)	0.05514289
Skewness	-164.04417
Sum	-17459.238
Variance	0.88753565
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-0.2008111	45432	1.8%
-0.2011434	42682	1.7%
-0.19431382	31017	1.2%
-0.20031251	26327	1.0%
-0.20446117	23665	0.9%
-0.1949817	23210	0.9%
-0.20097728	15691	0.6%
-0.18324877	13989	0.5%
-0.1934785	13468	0.5%
-0.18173373	10708	0.4%
Other values (23993)	2322535	90.4%

Value	Count	Frequency (%)
-771.33545	1	< 0.1%
-61.64089	1	< 0.1%
-29.762724	1	< 0.1%
-26.37837	1	< 0.1%
-25.775064	1	< 0.1%
-19.070955	1	< 0.1%
-17.54647	1	< 0.1%
-8.662593	1	< 0.1%
-7.8481994	1	< 0.1%
-3.4135826	4	< 0.1%

Value	Count	Frequency (%)
276.4262	1	< 0.1%
257.34677	1	< 0.1%
194.21335	1	< 0.1%
189.49796	1	< 0.1%
143.91191	1	< 0.1%
139.13548	1	< 0.1%
129.52835	1	< 0.1%
123.93126	1	< 0.1%
123.90715	4	< 0.1%
114.30045	1	< 0.1%

edad_promedio
Real number (ℝ)

High correlation

Distinct	32
Distinct (%)	< 0.1%
Missing	4954
Missing (%)	0.2%
Infinite	0
Infinite (%)	0.0%
Mean	35.674954

Minimum	28.311825
Maximum	41.152468
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	19.6 MiB

Quantile statistics

Minimum	28.311825
5-th percentile	29.862683
Q1	34.193915
median	37.077072
Q3	38.001476
95-th percentile	39.272306
Maximum	41.152468
Range	12.840643
Interquartile range (IQR)	3.8075606

Descriptive statistics

Standard deviation	3.3572433
Coefficient of variation (CV)	0.094106449
Kurtosis	-0.72522187
Mean	35.674954
Median Absolute Deviation (MAD)	1.5686651
Skewness	-0.93713351
Sum	91462377
Variance	11.271082
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=32)

Value	Count	Frequency (%)
37.07707192	739403	28.8%
29.86268292	572599	22.3%
38.64573702	407942	15.9%
38.00147566	226327	8.8%
39.27230572	132899	5.2%
36.7491788	107104	4.2%
34.96857356	59121	2.3%
36.26800506	50586	2.0%
36.84756013	39420	1.5%
35.76903746	36280	1.4%
Other values (22)	192089	7.5%

Value	Count	Frequency (%)
28.31182473	27	< 0.1%
28.83482587	180	< 0.1%
29.86268292	572599	22.3%
31.20435967	26107	1.0%
31.66406992	16	< 0.1%
31.7555456	430	< 0.1%
32.10022272	793	< 0.1%
32.22589259	4018	0.2%
32.31182538	177	< 0.1%
33.17039184	1034	< 0.1%

Value	Count	Frequency (%)
41.15246802	8184	0.3%
40.63623799	5574	0.2%
39.27230572	132899	5.2%
38.64573702	407942	15.9%
38.00147566	226327	8.8%
37.71364425	20181	0.8%
37.68387216	27727	1.1%
37.46664198	159	< 0.1%
37.28770028	234	< 0.1%
37.07707192	739403	28.8%

ingreso_laboral_promedio
Real number (ℝ)

High correlation

Distinct	32
Distinct (%)	< 0.1%
Missing	4954
Missing (%)	0.2%
Infinite	0
Infinite (%)	0.0%
Mean	1616382.6

Minimum	1171393.5
Maximum	2593276
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	19.6 MiB

Quantile statistics

Minimum	1171393.5
5-th percentile	1212095.3
Q1	1404703.6
median	1577079.1
Q3	1801097.3
95-th percentile	2107814
Maximum	2593276
Range	1421882.5
Interquartile range (IQR)	396393.75

Descriptive statistics

Standard deviation	278703.85
Coefficient of variation (CV)	0.17242443
Kurtosis	-0.98872664
Mean	1616382.6
Median Absolute Deviation (MAD)	224018.21
Skewness	-0.082277501
Sum	4.1440333 × 10¹²
Variance	7.7675838 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=32)

Value	Count	Frequency (%)
1801097.339	739403	28.8%
1212095.342	572599	22.3%
1550360.891	407942	15.9%
2107813.959	226327	8.8%
1821178.566	132899	5.2%
1507068.661	107104	4.2%
1404703.587	59121	2.3%
1839749.174	50586	2.0%
1417425.912	39420	1.5%
1577079.13	36280	1.4%
Other values (22)	192089	7.5%

Value	Count	Frequency (%)
1171393.493	3198	0.1%
1212095.342	572599	22.3%
1243626.566	793	< 0.1%
1307811.243	4018	0.2%
1310843.249	5591	0.2%
1348154.753	4285	0.2%
1388253.883	18671	0.7%
1404703.587	59121	2.3%
1417425.912	39420	1.5%
1434209.509	20181	0.8%

Value	Count	Frequency (%)
2593275.96	159	< 0.1%
2229208.752	16	< 0.1%
2107813.959	226327	8.8%
2004599.926	26107	1.0%
1901364.142	8184	0.3%
1866250.314	234	< 0.1%
1839749.174	50586	2.0%
1831205.93	33648	1.3%
1821178.566	132899	5.2%
1801097.339	739403	28.8%

porcentaje_urbano
Real number (ℝ)

High correlation

Distinct	24
Distinct (%)	< 0.1%
Missing	4954
Missing (%)	0.2%
Infinite	0
Infinite (%)	0.0%
Mean	84.754443

Minimum	67.91
Maximum	100
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	19.6 MiB

Quantile statistics

Minimum	67.91
5-th percentile	80.7
Q1	83.79
median	86.48
Q3	86.88
95-th percentile	87.94
Maximum	100
Range	32.09
Interquartile range (IQR)	3.09

Descriptive statistics

Standard deviation	4.5114472
Coefficient of variation (CV)	0.053229625
Kurtosis	6.7473447
Mean	84.754443
Median Absolute Deviation (MAD)	1.69
Skewness	-1.7625147
Sum	2.172909 × 10⁸
Variance	20.353156
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=24)

Value	Count	Frequency (%)
86.88	739403	28.8%
84.79	572599	22.3%
80.7	407942	15.9%
87.64	226327	8.8%
87.94	132899	5.2%
67.91	107104	4.2%
87.54	59121	2.3%
83.43	50586	2.0%
83.79	39420	1.5%
84.45	36280	1.4%
Other values (14)	192089	7.5%

Value	Count	Frequency (%)
67.91	107104	4.2%
80.7	407942	15.9%
83.12	4285	0.2%
83.43	50586	2.0%
83.56	33648	1.3%
83.79	39420	1.5%
84.26	1034	< 0.1%
84.45	36280	1.4%
84.79	572599	22.3%
85.64	20181	0.8%

Value	Count	Frequency (%)
100	28710	1.1%
97.5	159	< 0.1%
88.81	31109	1.2%
88.75	5574	0.2%
88.46	27727	1.1%
87.94	132899	5.2%
87.64	226327	8.8%
87.54	59121	2.3%
87.09	18671	0.7%
86.88	739403	28.8%

IPUG
Real number (ℝ)

High correlation

Distinct	25
Distinct (%)	< 0.1%
Missing	5
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	840471.69

Minimum	395366
Maximum	1935816
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	19.6 MiB

Quantile statistics

Minimum	395366
5-th percentile	395366
Q1	595819
median	956065
Q3	1056184
95-th percentile	1250932
Maximum	1935816
Range	1540450
Interquartile range (IQR)	460365

Descriptive statistics

Standard deviation	288446.6
Coefficient of variation (CV)	0.3431961
Kurtosis	-1.1850811
Mean	840471.69
Median Absolute Deviation (MAD)	185607
Skewness	-0.41928982
Sum	2.1589356 × 10¹²
Variance	8.3201443 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=25)

Value	Count	Frequency (%)
1056184	739403	28.8%
395366	572599	22.3%
770458	407942	15.9%
1250932	226327	8.8%
1049362	132899	5.2%
1096893	107104	4.2%
753265	59121	2.3%
811720	50586	2.0%
595819	39420	1.5%
684916	36280	1.4%
Other values (15)	197038	7.7%

Value	Count	Frequency (%)
395366	572599	22.3%
416159	4949	0.2%
529491	3198	0.1%
550320	28710	1.1%
565106	4285	0.2%
585909	4018	0.2%
595819	39420	1.5%
612838	5591	0.2%
643962	1034	< 0.1%
680424	18671	0.7%

Value	Count	Frequency (%)
1935816	159	< 0.1%
1250932	226327	8.8%
1102287	27727	1.1%
1096893	107104	4.2%
1082481	8184	0.3%
1056184	739403	28.8%
1049362	132899	5.2%
1002858	5574	0.2%
980735	31109	1.2%
956065	33648	1.3%

GINI
Real number (ℝ)

High correlation

Distinct	28
Distinct (%)	< 0.1%
Missing	5
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	0.5143927

Minimum	0.442
Maximum	0.95
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	19.6 MiB

Quantile statistics

Minimum	0.442
5-th percentile	0.471
Q1	0.501
median	0.512
Q3	0.524
95-th percentile	0.536
Maximum	0.95
Range	0.508
Interquartile range (IQR)	0.023

Descriptive statistics

Standard deviation	0.038863934
Coefficient of variation (CV)	0.075553044
Kurtosis	48.723919
Mean	0.5143927
Median Absolute Deviation (MAD)	0.011
Skewness	6.0249114
Sum	1321330.3
Variance	0.0015104054
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=28)

Value	Count	Frequency (%)
0.501	739403	28.8%
0.536	572599	22.3%
0.518	407942	15.9%
0.524	226327	8.8%
0.471	225668	8.8%
0.506	107104	4.2%
0.512	58091	2.3%
0.498	50586	2.0%
0.472	36280	1.4%
0.486	31109	1.2%
Other values (18)	113610	4.4%

Value	Count	Frequency (%)
0.442	1034	< 0.1%
0.465	5574	0.2%
0.471	225668	8.8%
0.472	36280	1.4%
0.486	31109	1.2%
0.487	5591	0.2%
0.491	8184	0.3%
0.492	3198	0.1%
0.497	20181	0.8%
0.498	50586	2.0%

Value	Count	Frequency (%)
0.95	180	< 0.1%
0.84	26107	1.0%
0.71	1176	< 0.1%
0.67	234	< 0.1%
0.589	4949	0.2%
0.56	43	< 0.1%
0.54	793	< 0.1%
0.536	572599	22.3%
0.53	159	< 0.1%
0.524	226327	8.8%

total_productos
Real number (ℝ)

High correlation Skewed

Distinct	71035
Distinct (%)	2.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4404.9228

Minimum	0.4
Maximum	2070111.4
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	19.6 MiB

Quantile statistics

Minimum	0.4
5-th percentile	2
Q1	28.44
median	163.2
Q3	581.94
95-th percentile	2639.32
Maximum	2070111.4
Range	2070111
Interquartile range (IQR)	553.5

Descriptive statistics

Standard deviation	73699.706
Coefficient of variation (CV)	16.731214
Kurtosis	590.18325
Mean	4404.9228
Median Absolute Deviation (MAD)	156.45
Skewness	23.569078
Sum	1.1315031 × 10¹⁰
Variance	5.4316466 × 10⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	62574	2.4%
2	60029	2.3%
3	44612	1.7%
4	38760	1.5%
5	28895	1.1%
6	25611	1.0%
7	18681	0.7%
8	17326	0.7%
9	13568	0.5%
10	13295	0.5%
Other values (71025)	2245373	87.4%

Value	Count	Frequency (%)
0.4	6	< 0.1%
0.48	14	< 0.1%
0.52	5	< 0.1%
0.54	2	< 0.1%
0.8	4	< 0.1%
0.84	4	< 0.1%
0.96	11	< 0.1%
0.98	1	< 0.1%
1	62574	2.4%
1.02	1	< 0.1%

Value	Count	Frequency (%)
2070111.4	1555	0.1%
1733209.4	1671	0.1%
1140865.5	94	< 0.1%
1021267.8	38	< 0.1%
952663.2	1735	0.1%
523610.44	1361	0.1%
504107	26	< 0.1%
442087.66	55	< 0.1%
336561	45	< 0.1%
331882.56	51	< 0.1%

total_gasto
Real number (ℝ)

High correlation

Distinct	93148
Distinct (%)	3.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3188.546

Minimum	0.07
Maximum	912072.44
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	19.6 MiB

Quantile statistics

Minimum	0.07
5-th percentile	10.849999
Q1	77.380005
median	247.9
Q3	636.31995
95-th percentile	3023.46
Maximum	912072.44
Range	912072.37
Interquartile range (IQR)	558.93994

Descriptive statistics

Standard deviation	41173.977
Coefficient of variation (CV)	12.913088
Kurtosis	350.93192
Mean	3188.546
Median Absolute Deviation (MAD)	204.95
Skewness	18.33987
Sum	8.1904947 × 10⁹
Variance	1.6952963 × 10⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
812211.94	1735	0.1%
912072.44	1671	0.1%
757335.44	1555	0.1%
464574.28	1361	0.1%
573531.44	1318	0.1%
12543.24	1173	< 0.1%
1.13	1155	< 0.1%
19.88	1134	< 0.1%
18.47	1080	< 0.1%
1.2	1033	< 0.1%
Other values (93138)	2555509	99.5%

Value	Count	Frequency (%)
0.07	2	< 0.1%
0.09	1	< 0.1%
0.12	1	< 0.1%
0.13	1	< 0.1%
0.15	3	< 0.1%
0.24	5	< 0.1%
0.25	1	< 0.1%
0.26	5	< 0.1%
0.27	5	< 0.1%
0.28	6	< 0.1%

Value	Count	Frequency (%)
912072.44	1671	0.1%
812211.94	1735	0.1%
757335.44	1555	0.1%
573531.44	1318	0.1%
464574.28	1361	0.1%
396370.2	945	< 0.1%
247083.06	644	< 0.1%
186000.83	94	< 0.1%
149620.8	181	< 0.1%
129457.25	461	< 0.1%

precio_promedio
Real number (ℝ)

High correlation Skewed

Distinct	260446
Distinct (%)	10.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.4421912

Minimum	0.0039547062
Maximum	2177.81
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	19.6 MiB

Quantile statistics

Minimum	0.0039547062
5-th percentile	0.38869548
Q1	0.6737593
median	1.5778431
Q3	3.6011639
95-th percentile	19.027935
Maximum	2177.81
Range	2177.806
Interquartile range (IQR)	2.9274046

Descriptive statistics

Standard deviation	10.496226
Coefficient of variation (CV)	2.3628488
Kurtosis	2438.0341
Mean	4.4421912
Median Absolute Deviation (MAD)	1.0798431
Skewness	24.843452
Sum	11410763
Variance	110.17076
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.85257	1735	0.1%
0.52623326	1671	0.1%
0.36584282	1555	0.1%
0.6	1415	0.1%
0.65	1378	0.1%
0.88725173	1361	0.1%
3.1338317	1318	0.1%
0.565	1300	0.1%
2.9663782	1173	< 0.1%
18.47	1142	< 0.1%
Other values (260436)	2554676	99.5%

Value	Count	Frequency (%)
0.0039547062	1	< 0.1%
0.00685977	6	< 0.1%
0.0073786806	9	< 0.1%
0.007571423	7	< 0.1%
0.008853219	9	< 0.1%
0.009492378	13	< 0.1%
0.015799172	111	< 0.1%
0.016728375	17	< 0.1%
0.018946793	71	< 0.1%
0.024560008	33	< 0.1%

Value	Count	Frequency (%)
2177.81	1	< 0.1%
1703.4	1	< 0.1%
1607.53	1	< 0.1%
1437.48	3	< 0.1%
1408.16	2	< 0.1%
1010.53	1	< 0.1%
849.62	1	< 0.1%
821.0675	4	< 0.1%
795.42	2	< 0.1%
795.01	1	< 0.1%

num_pedidos
Real number (ℝ)

High correlation

Distinct	128
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	9.5446296

Minimum	1
Maximum	1133
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	19.6 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	2
median	3
Q3	6
95-th percentile	20
Maximum	1133
Range	1132
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	56.246915
Coefficient of variation (CV)	5.8930433
Kurtosis	276.17543
Mean	9.5446296
Median Absolute Deviation (MAD)	2
Skewness	15.946754
Sum	24517519
Variance	3163.7154
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	610854	23.8%
2	464762	18.1%
3	334652	13.0%
4	241867	9.4%
5	177691	6.9%
6	130856	5.1%
7	100684	3.9%
8	76597	3.0%
9	59873	2.3%
10	48727	1.9%
Other values (118)	322161	12.5%

Value	Count	Frequency (%)
1	610854	23.8%
2	464762	18.1%
3	334652	13.0%
4	241867	9.4%
5	177691	6.9%
6	130856	5.1%
7	100684	3.9%
8	76597	3.0%
9	59873	2.3%
10	48727	1.9%

Value	Count	Frequency (%)
1133	1735	0.1%
1029	1671	0.1%
1015	1555	0.1%
860	1361	0.1%
562	1173	< 0.1%
559	945	< 0.1%
485	1318	0.1%
404	998	< 0.1%
348	644	< 0.1%
312	318	< 0.1%

ticket_promedio
Real number (ℝ)

High correlation

Distinct	131307
Distinct (%)	5.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	121.69413

Minimum	0.07
Maximum	18707.72
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	19.6 MiB

Quantile statistics

Minimum	0.07
5-th percentile	7.455
Q1	32.17575
median	71.64333
Q3	142.26875
95-th percentile	382.50497
Maximum	18707.72
Range	18707.65
Interquartile range (IQR)	110.093

Descriptive statistics

Standard deviation	200.62754
Coefficient of variation (CV)	1.6486213
Kurtosis	604.72823
Mean	121.69413
Median Absolute Deviation (MAD)	47.34833
Skewness	14.452625
Sum	3.1259864 × 10⁸
Variance	40251.409
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
716.8684	1735	0.1%
886.3678	1671	0.1%
746.1433	1555	0.1%
540.20264	1361	0.1%
1182.5391	1318	0.1%
1.13	1257	< 0.1%
19.88	1184	< 0.1%
22.318933	1173	< 0.1%
1.2	1141	< 0.1%
18.47	1121	< 0.1%
Other values (131297)	2555208	99.5%

Value	Count	Frequency (%)
0.07	2	< 0.1%
0.09	1	< 0.1%
0.12	1	< 0.1%
0.13	1	< 0.1%
0.15	3	< 0.1%
0.24	5	< 0.1%
0.25	1	< 0.1%
0.26	5	< 0.1%
0.27	5	< 0.1%
0.28	6	< 0.1%

Value	Count	Frequency (%)
18707.72	2	< 0.1%
18029.578	6	< 0.1%
17066.71	5	< 0.1%
12910.56	2	< 0.1%
11729.96	3	< 0.1%
8857.183	94	< 0.1%
8598.75	13	< 0.1%
7946.05	24	< 0.1%
7676.9	1	< 0.1%
7607.127	3	< 0.1%

cantidad_promedio
Real number (ℝ)

High correlation Skewed

Distinct	94247
Distinct (%)	3.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	121.55906

Minimum	0.4
Maximum	100145.5
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	19.6 MiB

Quantile statistics

Minimum	0.4
5-th percentile	1.6666666
Q1	10.28
median	44.787777
Q3	128.6355
95-th percentile	435.4
Maximum	100145.5
Range	100145.1
Interquartile range (IQR)	118.3555

Descriptive statistics

Standard deviation	495.7702
Coefficient of variation (CV)	4.0784305
Kurtosis	8129.2788
Mean	121.55906
Median Absolute Deviation (MAD)	40.787777
Skewness	73.019714
Sum	3.1225168 × 10⁸
Variance	245788.09
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	79745	3.1%
2	66342	2.6%
3	41844	1.6%
4	30425	1.2%
5	20488	0.8%
6	16541	0.6%
1.5	14438	0.6%
2.5	10913	0.4%
7	9654	0.4%
8	8261	0.3%
Other values (94237)	2270073	88.4%

Value	Count	Frequency (%)
0.4	8	< 0.1%
0.48	18	< 0.1%
0.52	5	< 0.1%
0.54	2	< 0.1%
0.6	2	< 0.1%
0.665	2	< 0.1%
0.7	2	< 0.1%
0.71999997	2	< 0.1%
0.74	4	< 0.1%
0.8	2	< 0.1%

Value	Count	Frequency (%)
100145.5	3	< 0.1%
54326.93	94	< 0.1%
42008.918	26	< 0.1%
40013	6	< 0.1%
31914.62	38	< 0.1%
18227.256	53	< 0.1%
17085.857	9	< 0.1%
17000	1	< 0.1%
16638	7	< 0.1%
15244.402	55	< 0.1%

categorias_diferentes
Categorical

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	122.5 MiB

1	942232
2	869680
3	528945
4	201365
5	26502

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	2568724
Distinct characters	5
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	3
2nd row	1
3rd row	1
4th row	1
5th row	1

Common Values

Value	Count	Frequency (%)
1	942232	36.7%
2	869680	33.9%
3	528945	20.6%
4	201365	7.8%
5	26502	1.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1	942232	36.7%
2	869680	33.9%
3	528945	20.6%
4	201365	7.8%
5	26502	1.0%

Most occurring characters

Value	Count	Frequency (%)
1	942232	36.7%
2	869680	33.9%
3	528945	20.6%
4	201365	7.8%
5	26502	1.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	2568724	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
1	942232	36.7%
2	869680	33.9%
3	528945	20.6%
4	201365	7.8%
5	26502	1.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	2568724	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
1	942232	36.7%
2	869680	33.9%
3	528945	20.6%
4	201365	7.8%
5	26502	1.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	2568724	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
1	942232	36.7%
2	869680	33.9%
3	528945	20.6%
4	201365	7.8%
5	26502	1.0%

Total de edificaciones en obra
Real number (ℝ)

Zeros

Distinct	92
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	8.9911559

Minimum	0
Maximum	654
Zeros	678206
Zeros (%)	26.4%
Negative	0
Negative (%)	0.0%
Memory size	19.6 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	4
Q3	6
95-th percentile	27
Maximum	654
Range	654
Interquartile range (IQR)	6

Descriptive statistics

Standard deviation	35.698612
Coefficient of variation (CV)	3.9704141
Kurtosis	124.03997
Mean	8.9911559
Median Absolute Deviation (MAD)	3
Skewness	10.876594
Sum	23095798
Variance	1274.3909
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	678206	26.4%
6	610549	23.8%
1	303926	11.8%
3	220156	8.6%
10	143655	5.6%
16	142501	5.5%
27	77243	3.0%
2	66825	2.6%
13	59062	2.3%
5	47566	1.9%
Other values (82)	219035	8.5%

Value	Count	Frequency (%)
0	678206	26.4%
1	303926	11.8%
2	66825	2.6%
3	220156	8.6%
4	35704	1.4%
5	47566	1.9%
6	610549	23.8%
7	39016	1.5%
8	6103	0.2%
9	18646	0.7%

Value	Count	Frequency (%)
654	69	< 0.1%
451	395	< 0.1%
425	16697	0.7%
367	37	< 0.1%
299	70	< 0.1%
251	2	< 0.1%
223	6	< 0.1%
215	238	< 0.1%
202	162	< 0.1%
190	558	< 0.1%

Interactions

Correlations

	GINI	IPUG	Total de edificaciones en obra	ajustada_alineacion	alineación con portafolio estratégico	cantidad	cantidad_promedio	categoria	categoria_macro	categorias_diferentes	cluster	edad	edad_promedio	id	ingreso_laboral_promedio	log_cantidad	log_precio	log_valor	num_pedidos	pedido	porcentaje_urbano	precio	precio_promedio	ticket_promedio	total_gasto	total_productos	valor	zona
GINI	1.000	-0.466	-0.103	-0.040	-0.040	-0.014	-0.016	0.029	0.031	0.020	0.093	-0.022	-0.383	0.003	-0.520	-0.014	-0.023	-0.043	0.015	-0.004	-0.321	-0.023	-0.041	-0.069	-0.036	-0.006	-0.043	1.000
IPUG	-0.466	1.000	0.161	0.020	0.020	0.005	0.017	0.048	0.041	0.048	0.198	0.043	0.532	0.002	0.800	0.005	0.007	0.022	-0.019	0.005	0.442	0.007	0.029	0.060	0.031	0.007	0.022	1.000
Total de edificaciones en obra	-0.103	0.161	1.000	-0.000	-0.000	-0.004	-0.015	0.007	0.007	0.009	0.035	-0.001	-0.219	0.006	0.118	-0.004	0.001	0.001	-0.018	-0.003	0.286	0.001	0.010	-0.010	-0.019	-0.020	0.001	0.401
ajustada_alineacion	-0.040	0.020	-0.000	1.000	1.000	0.366	0.182	0.025	0.015	0.006	0.048	-0.067	0.018	-0.059	0.037	0.366	0.493	0.982	0.093	-0.006	0.013	0.493	0.101	0.368	0.307	0.188	0.982	0.005
alineación con portafolio estratégico	-0.040	0.020	-0.000	1.000	1.000	0.366	0.182	0.026	0.017	0.005	0.053	-0.067	0.018	-0.059	0.037	0.366	0.493	0.982	0.093	-0.006	0.013	0.493	0.101	0.368	0.307	0.188	0.982	0.004
cantidad	-0.014	0.005	-0.004	0.366	0.366	1.000	0.420	0.036	0.006	0.003	0.064	-0.039	0.008	-0.057	0.014	1.000	-0.530	0.387	0.076	-0.011	-0.014	-0.530	-0.390	0.212	0.187	0.355	0.387	0.006
cantidad_promedio	-0.016	0.017	-0.015	0.182	0.182	0.420	1.000	0.048	0.013	0.016	0.085	-0.077	0.024	-0.120	0.034	0.420	-0.234	0.188	0.221	-0.002	-0.035	-0.234	-0.725	0.697	0.602	0.875	0.188	0.034
categoria	0.029	0.048	0.007	0.025	0.026	0.036	0.048	1.000	1.000	0.155	0.086	0.039	0.042	0.025	0.035	0.258	0.474	0.235	0.058	0.015	0.040	0.060	0.120	0.019	0.033	0.030	0.017	0.031
categoria_macro	0.031	0.041	0.007	0.015	0.017	0.006	0.013	1.000	1.000	0.126	0.087	0.026	0.043	0.021	0.031	0.322	0.356	0.101	0.057	0.018	0.034	0.043	0.014	0.011	0.024	0.018	0.004	0.055
categorias_diferentes	0.020	0.048	0.009	0.006	0.005	0.003	0.016	0.155	0.126	1.000	0.089	0.049	0.049	0.150	0.034	0.051	0.078	0.044	0.106	0.023	0.049	0.020	0.006	0.014	0.087	0.082	0.008	0.070
cluster	0.093	0.198	0.035	0.048	0.053	0.064	0.085	0.086	0.087	0.089	1.000	0.055	0.181	0.040	0.118	0.068	0.061	0.088	0.203	0.015	0.150	0.032	0.010	0.072	0.226	0.210	0.055	0.244
edad	-0.022	0.043	-0.001	-0.067	-0.067	-0.039	-0.077	0.039	0.026	0.049	0.055	1.000	0.040	0.057	0.025	-0.039	-0.029	-0.068	-0.080	-0.002	0.021	-0.029	-0.017	-0.129	-0.139	-0.104	-0.068	0.089
edad_promedio	-0.383	0.532	-0.219	0.018	0.018	0.008	0.024	0.042	0.043	0.049	0.181	0.040	1.000	-0.008	0.616	0.008	0.006	0.016	0.015	0.009	0.141	0.006	0.007	0.047	0.044	0.029	0.016	1.000
id	0.003	0.002	0.006	-0.059	-0.059	-0.057	-0.120	0.025	0.021	0.150	0.040	0.057	-0.008	1.000	-0.011	-0.057	-0.009	-0.061	-0.505	0.524	0.018	-0.009	0.051	-0.108	-0.386	-0.336	-0.061	0.034
ingreso_laboral_promedio	-0.520	0.800	0.118	0.037	0.037	0.014	0.034	0.035	0.031	0.034	0.118	0.025	0.616	-0.011	1.000	0.014	0.016	0.040	-0.000	0.006	0.570	0.016	0.031	0.087	0.057	0.027	0.040	1.000
log_cantidad	-0.014	0.005	-0.004	0.366	0.366	1.000	0.420	0.258	0.322	0.051	0.068	-0.039	0.008	-0.057	0.014	1.000	-0.530	0.387	0.076	-0.011	-0.014	-0.530	-0.390	0.212	0.187	0.355	0.387	0.038
log_precio	-0.023	0.007	0.001	0.493	0.493	-0.530	-0.234	0.474	0.356	0.078	0.061	-0.029	0.006	-0.009	0.016	-0.530	1.000	0.485	0.029	0.006	0.019	1.000	0.432	0.092	0.085	-0.162	0.485	0.025
log_valor	-0.043	0.022	0.001	0.982	0.982	0.387	0.188	0.235	0.101	0.044	0.088	-0.068	0.016	-0.061	0.040	0.387	0.485	1.000	0.091	-0.006	0.009	0.485	0.086	0.360	0.300	0.192	1.000	0.064
num_pedidos	0.015	-0.019	-0.018	0.093	0.093	0.076	0.221	0.058	0.057	0.106	0.203	-0.080	0.015	-0.505	-0.000	0.076	0.029	0.091	1.000	0.016	-0.038	0.029	-0.110	0.178	0.721	0.629	0.091	0.180
pedido	-0.004	0.005	-0.003	-0.006	-0.006	-0.011	-0.002	0.015	0.018	0.023	0.015	-0.002	0.009	0.524	0.006	-0.011	0.006	-0.006	0.016	1.000	-0.001	0.006	0.003	-0.000	0.009	0.006	-0.006	0.014
porcentaje_urbano	-0.321	0.442	0.286	0.013	0.013	-0.014	-0.035	0.040	0.034	0.049	0.150	0.021	0.141	0.018	0.570	-0.014	0.019	0.009	-0.038	-0.001	1.000	0.019	0.049	0.007	-0.017	-0.042	0.009	1.000
precio	-0.023	0.007	0.001	0.493	0.493	-0.530	-0.234	0.060	0.043	0.020	0.032	-0.029	0.006	-0.009	0.016	-0.530	1.000	0.485	0.029	0.006	0.019	1.000	0.432	0.092	0.085	-0.162	0.485	0.000
precio_promedio	-0.041	0.029	0.010	0.101	0.101	-0.390	-0.725	0.120	0.014	0.006	0.010	-0.017	0.007	0.051	0.031	-0.390	0.432	0.086	-0.110	0.003	0.049	0.432	1.000	-0.066	-0.104	-0.611	0.086	0.005
ticket_promedio	-0.069	0.060	-0.010	0.368	0.368	0.212	0.697	0.019	0.011	0.014	0.072	-0.129	0.047	-0.108	0.087	0.212	0.092	0.360	0.178	-0.000	0.007	0.092	-0.066	1.000	0.780	0.627	0.360	0.042
total_gasto	-0.036	0.031	-0.019	0.307	0.307	0.187	0.602	0.033	0.024	0.087	0.226	-0.139	0.044	-0.386	0.057	0.187	0.085	0.300	0.721	0.009	-0.017	0.085	-0.104	0.780	1.000	0.824	0.300	0.197
total_productos	-0.006	0.007	-0.020	0.188	0.188	0.355	0.875	0.030	0.018	0.082	0.210	-0.104	0.029	-0.336	0.027	0.355	-0.162	0.192	0.629	0.006	-0.042	-0.162	-0.611	0.627	0.824	1.000	0.192	0.180
valor	-0.043	0.022	0.001	0.982	0.982	0.387	0.188	0.017	0.004	0.008	0.055	-0.068	0.016	-0.061	0.040	0.387	0.485	1.000	0.091	-0.006	0.009	0.485	0.086	0.360	0.300	0.192	1.000	0.027
zona	1.000	1.000	0.401	0.005	0.004	0.006	0.034	0.031	0.055	0.070	0.244	0.089	1.000	0.034	1.000	0.038	0.025	0.064	0.180	0.014	1.000	0.000	0.005	0.042	0.197	0.180	0.027	1.000

Missing values

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

Sample

	fecha	pedido	id	edad	municipio	zona	asesor	punto de venta	cluster	categoria_macro	categoria	subcategoria	producto	color	cantidad	precio	valor	alineación con portafolio estratégico	log_cantidad	log_precio	log_valor	ajustada_alineacion	edad_promedio	ingreso_laboral_promedio	porcentaje_urbano	IPUG	GINI	total_productos	total_gasto	precio_promedio	num_pedidos	ticket_promedio	cantidad_promedio	categorias_diferentes	Total de edificaciones en obra
0	1971-04-30	2	2	52	EL CARMEN DE CHUCURI	SANTANDER	asesor_2	punto_venta_2	cluster_tienda_2	categoria_macro_1	categoria_2	subcategoria_2	producto_2	GRIS	1.00	32.88	32.88	2.920320	0.693147	3.522825	3.522825	-0.061772	37.077072	1.801097e+06	86.88	1056184.0	0.501	77.040000	389.13	5.051012	12	32.4275	6.420000	3	2.0
1	1971-04-30	3	3	31	VILLANUEVA	LA GUAJIRA	asesor_3	punto_venta_2	cluster_tienda_2	categoria_macro_2	categoria_3	subcategoria_3	producto_3	BEIGE	2.00	0.56	1.13	0.117504	1.098612	0.444686	0.756122	-0.201143	29.862683	1.212095e+06	84.79	395366.0	0.536	2.000000	1.13	0.565000	1	1.1300	2.000000	1	1.0
2	1971-04-30	3	3	31	VILLANUEVA	LA GUAJIRA	asesor_3	punto_venta_2	cluster_tienda_2	categoria_macro_2	categoria_3	subcategoria_3	producto_3	BEIGE	2.00	0.56	1.13	0.117504	1.098612	0.444686	0.756122	-0.201143	29.862683	1.212095e+06	84.79	395366.0	0.536	2.000000	1.13	0.565000	1	1.1300	2.000000	1	10.0
3	1971-04-30	3	3	31	VILLANUEVA	LA GUAJIRA	asesor_3	punto_venta_2	cluster_tienda_2	categoria_macro_2	categoria_3	subcategoria_3	producto_3	BEIGE	2.00	0.56	1.13	0.117504	1.098612	0.444686	0.756122	-0.201143	29.862683	1.212095e+06	84.79	395366.0	0.536	2.000000	1.13	0.565000	1	1.1300	2.000000	1	16.0
4	1971-04-30	3	3	31	VILLANUEVA	LA GUAJIRA	asesor_3	punto_venta_2	cluster_tienda_2	categoria_macro_2	categoria_3	subcategoria_3	producto_3	BEIGE	2.00	0.56	1.13	0.117504	1.098612	0.444686	0.756122	-0.201143	29.862683	1.212095e+06	84.79	395366.0	0.536	2.000000	1.13	0.565000	1	1.1300	2.000000	1	0.0
5	1971-04-30	4	4	43	VILLANUEVA	LA GUAJIRA	asesor_4	punto_venta_2	cluster_tienda_2	categoria_macro_3	categoria_4	subcategoria_4	producto_4	No encontrado	1.00	8.38	8.38	1.251072	0.693147	2.238580	2.238580	-0.145693	29.862683	1.212095e+06	84.79	395366.0	0.536	1.000000	8.38	8.380000	1	8.3800	1.000000	1	1.0
6	1971-04-30	4	4	43	VILLANUEVA	LA GUAJIRA	asesor_4	punto_venta_2	cluster_tienda_2	categoria_macro_3	categoria_4	subcategoria_4	producto_4	No encontrado	1.00	8.38	8.38	1.251072	0.693147	2.238580	2.238580	-0.145693	29.862683	1.212095e+06	84.79	395366.0	0.536	1.000000	8.38	8.380000	1	8.3800	1.000000	1	10.0
7	1971-04-30	4	4	43	VILLANUEVA	LA GUAJIRA	asesor_4	punto_venta_2	cluster_tienda_2	categoria_macro_3	categoria_4	subcategoria_4	producto_4	No encontrado	1.00	8.38	8.38	1.251072	0.693147	2.238580	2.238580	-0.145693	29.862683	1.212095e+06	84.79	395366.0	0.536	1.000000	8.38	8.380000	1	8.3800	1.000000	1	16.0
8	1971-04-30	4	4	43	VILLANUEVA	LA GUAJIRA	asesor_4	punto_venta_2	cluster_tienda_2	categoria_macro_3	categoria_4	subcategoria_4	producto_4	No encontrado	1.00	8.38	8.38	1.251072	0.693147	2.238580	2.238580	-0.145693	29.862683	1.212095e+06	84.79	395366.0	0.536	1.000000	8.38	8.380000	1	8.3800	1.000000	1	0.0
9	1971-04-30	5	5	31	VILLANUEVA	LA GUAJIRA	asesor_5	punto_venta_3	cluster_tienda_3	categoria_macro_2	categoria_5	subcategoria_5	producto_5	BLANCO	21.14	2.27	47.99	3.729024	3.097386	1.184790	3.891616	-0.020477	29.862683	1.212095e+06	84.79	395366.0	0.536	54.809998	73.50	1.340996	3	24.5000	18.269999	2	1.0

	fecha	pedido	id	edad	municipio	zona	asesor	punto de venta	cluster	categoria_macro	categoria	subcategoria	producto	color	cantidad	precio	valor	alineación con portafolio estratégico	log_cantidad	log_precio	log_valor	ajustada_alineacion	edad_promedio	ingreso_laboral_promedio	porcentaje_urbano	IPUG	GINI	total_productos	total_gasto	precio_promedio	num_pedidos	ticket_promedio	cantidad_promedio	categorias_diferentes	Total de edificaciones en obra
2568714	1972-09-01	933930	419221	29	CURITI	SANTANDER	asesor_380	punto_venta_10	cluster_tienda_3	categoria_macro_1	categoria_1	subcategoria_26	producto_410	No encontrado	1.00	0.92	0.92	0.082944	0.693147	0.652325	0.652325	-0.202803	37.077072	1.801097e+06	86.88	1056184.0	0.501	41.240000	93.65000	2.270853	3	31.216667	13.746667	3	6.0
2568715	1972-09-01	933931	419224	28	CASTILLA LA NUEVA	META	asesor_45	punto_venta_16	cluster_tienda_3	categoria_macro_4	categoria_9	subcategoria_25	producto_267	No encontrado	1.00	15.90	15.90	2.374272	0.693147	2.827314	2.827314	-0.089444	34.193915	1.831206e+06	83.56	956065.0	0.471	1.000000	15.90000	15.900000	1	15.900000	1.000000	1	6.0
2568716	1972-09-01	933932	419225	46	CURITI	SANTANDER	asesor_45	punto_venta_16	cluster_tienda_3	categoria_macro_4	categoria_9	subcategoria_25	producto_2690	No encontrado	1.00	20.46	20.46	3.335040	0.693147	3.066191	3.066191	-0.040638	37.077072	1.801097e+06	86.88	1056184.0	0.501	1.000000	20.46000	20.460000	1	20.460000	1.000000	1	6.0
2568717	1972-09-01	933933	368060	57	CURITI	SANTANDER	asesor_219	punto_venta_15	cluster_tienda_2	categoria_macro_2	categoria_5	subcategoria_5	producto_3200	MULTICOLOR	21.06	3.67	77.30	8.035200	3.093766	1.541159	4.360548	0.203878	37.077072	1.801097e+06	86.88	1056184.0	0.501	1144.450000	470.38000	0.411010	8	58.797500	143.056240	2	6.0
2568718	1972-09-01	933933	368060	57	CURITI	SANTANDER	asesor_219	punto_venta_15	cluster_tienda_2	categoria_macro_2	categoria_5	subcategoria_5	producto_699	GRIS	17.01	3.04	51.72	5.377536	2.890927	1.396245	3.964995	0.064639	37.077072	1.801097e+06	86.88	1056184.0	0.501	1144.450000	470.38000	0.411010	8	58.797500	143.056240	2	6.0
2568719	1972-09-01	933933	368060	57	CURITI	SANTANDER	asesor_219	punto_venta_15	cluster_tienda_2	categoria_macro_2	categoria_7	subcategoria_5	producto_3328	MULTICOLOR	45.50	2.73	124.03	11.021184	3.839452	1.316408	4.828554	0.362528	37.077072	1.801097e+06	86.88	1056184.0	0.501	1144.450000	470.38000	0.411010	8	58.797500	143.056240	2	6.0
2568720	1972-09-01	933934	78489	29	CASTILLA LA NUEVA	META	asesor_45	punto_venta_16	cluster_tienda_3	categoria_macro_2	categoria_5	subcategoria_5	producto_4719	BLANCO	8.64	3.56	30.78	2.865024	2.265921	1.517323	3.458837	-0.064583	34.193915	1.831206e+06	83.56	956065.0	0.471	569.240000	360.49002	0.633283	5	72.098010	113.848010	2	6.0
2568721	1972-09-01	933935	415279	42	CASTILLA LA NUEVA	META	asesor_45	punto_venta_16	cluster_tienda_3	categoria_macro_4	categoria_10	subcategoria_37	producto_1414	No encontrado	1.00	33.04	33.04	3.753216	0.693147	3.527536	3.527536	-0.019237	34.193915	1.831206e+06	83.56	956065.0	0.471	8.000000	100.30000	12.537500	3	33.433334	2.666667	1	6.0
2568722	1972-09-01	933936	419226	47	NATAGAIMA	TOLIMA	asesor_45	punto_venta_16	cluster_tienda_3	categoria_macro_2	categoria_5	subcategoria_5	producto_511	MARFIL	11.52	3.75	43.14	4.485888	2.527327	1.558145	3.787366	0.018460	38.645737	1.550361e+06	80.70	770458.0	0.518	13.120001	48.23000	3.676067	1	48.230000	13.120001	1	0.0
2568723	1972-09-01	933936	419226	47	NATAGAIMA	TOLIMA	asesor_45	punto_venta_16	cluster_tienda_3	categoria_macro_2	categoria_7	subcategoria_5	producto_248	No encontrado	1.60	3.18	5.09	0.452736	0.955511	1.430311	1.806648	-0.184930	38.645737	1.550361e+06	80.70	770458.0	0.518	13.120001	48.23000	3.676067	1	48.230000	13.120001	1	0.0

Duplicate rows

Most frequently occurring

	fecha	pedido	id	edad	municipio	zona	asesor	punto de venta	cluster	categoria_macro	categoria	subcategoria	producto	color	cantidad	precio	valor	alineación con portafolio estratégico	log_cantidad	log_precio	log_valor	ajustada_alineacion	edad_promedio	ingreso_laboral_promedio	porcentaje_urbano	IPUG	GINI	total_productos	total_gasto	precio_promedio	num_pedidos	ticket_promedio	cantidad_promedio	categorias_diferentes	# duplicates
0	1971-01-02	255243	148297	50	ARGELIA	CAUCA	asesor_138	punto_venta_21	cluster_tienda_3	categoria_macro_2	categoria_3	subcategoria_3	producto_40	No encontrado	2.00	0.56	1.13	0.141696	1.098612	0.444686	0.756122	-0.199980	36.84756	1.417426e+06	83.79	595819.0	0.512	509.88	903.490000	1.771966	14	64.534996	36.420000	4	2
1	1971-01-02	255243	148297	50	ARGELIA	CAUCA	asesor_138	punto_venta_21	cluster_tienda_3	categoria_macro_2	categoria_3	subcategoria_9	producto_72	GRIS	150.00	0.13	19.84	2.495232	5.017280	0.122218	3.036874	-0.083330	36.84756	1.417426e+06	83.79	595819.0	0.512	509.88	903.490000	1.771966	14	64.534996	36.420000	4	2
2	1971-01-02	255243	148297	50	ARGELIA	CAUCA	asesor_138	punto_venta_21	cluster_tienda_3	categoria_macro_2	categoria_5	subcategoria_5	producto_919	MARFIL	17.55	4.04	70.96	8.449920	2.920470	1.617406	4.276110	0.225788	36.84756	1.417426e+06	83.79	595819.0	0.512	509.88	903.490000	1.771966	14	64.534996	36.420000	4	2
3	1971-01-02	255243	148297	50	ARGELIA	CAUCA	asesor_138	punto_venta_21	cluster_tienda_3	categoria_macro_4	categoria_12	subcategoria_14	producto_221	No encontrado	1.00	43.91	43.91	4.565376	0.693147	3.804661	3.804661	0.022564	36.84756	1.417426e+06	83.79	595819.0	0.512	509.88	903.490000	1.771966	14	64.534996	36.420000	4	2
4	1971-01-02	256539	150249	39	ARGELIA	CAUCA	asesor_93	punto_venta_22	cluster_tienda_3	categoria_macro_2	categoria_5	subcategoria_5	producto_423	BLANCO	24.30	4.13	100.27	11.937024	3.230804	1.635106	4.617790	0.411565	36.84756	1.417426e+06	83.79	595819.0	0.512	151.65	117.270000	0.773294	3	39.090000	50.550000	2	2
5	1971-01-02	256910	159910	43	ARGELIA	CAUCA	asesor_111	punto_venta_21	cluster_tienda_3	categoria_macro_4	categoria_12	subcategoria_14	producto_221	No encontrado	1.00	43.91	43.91	4.565376	0.693147	3.804661	3.804661	0.022564	36.84756	1.417426e+06	83.79	595819.0	0.512	4.00	90.590000	22.647500	3	30.196665	1.333333	3	2
6	1971-01-02	256926	159910	43	ARGELIA	CAUCA	asesor_111	punto_venta_21	cluster_tienda_3	categoria_macro_2	categoria_3	subcategoria_3	producto_112	GRIS	2.00	0.56	1.13	0.141696	1.098612	0.444686	0.756122	-0.199980	36.84756	1.417426e+06	83.79	595819.0	0.512	4.00	90.590000	22.647500	3	30.196665	1.333333	3	2
7	1971-01-02	257202	160093	53	ARGELIA	CAUCA	asesor_138	punto_venta_21	cluster_tienda_3	categoria_macro_2	categoria_3	subcategoria_9	producto_170	GRIS	75.00	0.44	33.31	4.866048	4.330733	0.364643	3.535437	0.038111	36.84756	1.417426e+06	83.79	595819.0	0.512	76.00	48.970000	0.644342	2	24.485000	38.000000	1	2
8	1971-01-02	257337	160166	38	ARGELIA	CAUCA	asesor_91	punto_venta_21	cluster_tienda_3	categoria_macro_4	categoria_10	subcategoria_37	producto_1823	No encontrado	1.00	20.22	20.22	1.797120	0.693147	3.054944	3.054944	-0.118474	36.84756	1.417426e+06	83.79	595819.0	0.512	2.00	28.449999	14.224999	1	28.449999	2.000000	1	2
9	1971-01-02	257337	160166	38	ARGELIA	CAUCA	asesor_91	punto_venta_21	cluster_tienda_3	categoria_macro_4	categoria_9	subcategoria_10	producto_1218	No encontrado	1.00	8.23	8.23	0.321408	0.693147	2.222459	2.222459	-0.191304	36.84756	1.417426e+06	83.79	595819.0	0.512	2.00	28.449999	14.224999	1	28.449999	2.000000	1	2

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks